package queenb.net.entitybean;
// Generated Jan 9, 2010 9:01:28 AM by Hibernate Tools 3.2.1.GA

import java.lang.reflect.Field;
import java.sql.Date;
import queenb.net.datacontrol.Param;
import java.sql.SQLException;
import java.util.List;
import oracle.jdbc.OracleTypes;
import queenb.net.annotation.Mapping;
import queenb.net.datacontrol.DataStatement;
import queenb.net.datacontrol.DataControl;

/**
 * @Author thanhct
 */
public class C150 extends DataControl<C150> implements java.io.Serializable {

    @Mapping(name = "pc150", typeMapping = OracleTypes.CHAR)
    private String pc150;
    @Mapping(name = "fs200", typeMapping = OracleTypes.INTEGER)
    private int fs200;
    @Mapping(name = "FB050", typeMapping = OracleTypes.INTEGER)
    private int pb050;
    @Mapping(name = "FV050", typeMapping = OracleTypes.INTEGER)
    private int fv050;
    @Mapping(name = "PS250", typeMapping = OracleTypes.INTEGER)
    private int fs250;
    @Mapping(name = "fh150", typeMapping = OracleTypes.CHAR)
    public String fh150;
    @Mapping(name = "fc400", typeMapping = OracleTypes.CHAR)
    public String fc400;
    @Mapping(name = "fc650", typeMapping = OracleTypes.CHAR)
    public String fc650;
    @Mapping(name = "fc250", typeMapping = OracleTypes.CHAR)
    public String fc250;
    @Mapping(name = "fc450", typeMapping = OracleTypes.INTEGER)
    public int fc450;
    @Mapping(name = "fc550", typeMapping = OracleTypes.CHAR)
    public String fc550;
    @Mapping(name = "fc500", typeMapping = OracleTypes.INTEGER)
    public int fc500;
    @Mapping(name = "fn600", typeMapping = OracleTypes.INTEGER)
    public int fn600;
    @Mapping(name = "PN100", typeMapping = OracleTypes.INTEGER)
    public int pn100;
    @Mapping(name = "cv151", typeMapping = OracleTypes.CHAR)
    public String cv151;
    @Mapping(name = "cd152", typeMapping = OracleTypes.DATE)
    public Date cd152;
    @Mapping(name = "cd153", typeMapping = OracleTypes.DATE)
    public Date cd153;
    @Mapping(name = "cv154", typeMapping = OracleTypes.CHAR)
    public String cv154;
    @Mapping(name = "cd155", typeMapping = OracleTypes.DATE)
    public Date cd155;
    @Mapping(name = "cn156", typeMapping = OracleTypes.INTEGER)
    public int cn156;
    @Mapping(name = "cv157", typeMapping = OracleTypes.CHAR)
    public String cv157;
    @Mapping(name = "cv158", typeMapping = OracleTypes.CHAR)
    public String cv158;
    @Mapping(name = "cv159", typeMapping = OracleTypes.CHAR)
    public String cv159;
    @Mapping(name = "cv160", typeMapping = OracleTypes.CHAR)
    public String cv160;
    @Mapping(name = "cv161", typeMapping = OracleTypes.CHAR)
    public String cv161;
    @Mapping(name = "cv162", typeMapping = OracleTypes.CHAR)
    public String cv162;
    @Mapping(name = "cv163", typeMapping = OracleTypes.CHAR)
    public String cv163;
    @Mapping(name = "cv164", typeMapping = OracleTypes.CHAR)
    public String cv164;
    @Mapping(name = "cv165", typeMapping = OracleTypes.CHAR)
    public String cv165;
    @Mapping(name = "cv166", typeMapping = OracleTypes.CHAR)
    public String cv166;
    @Mapping(name = "cv167", typeMapping = OracleTypes.CHAR)
    public String cv167;
    @Mapping(name = "vn034", typeMapping = OracleTypes.INTEGER)
    public int vn034;
    @Mapping(name = "ROWSS", typeMapping = OracleTypes.INTEGER)
    private int row;
    private Date cl191;
    private String cl192;
    private Date cl193;
    private String cl194;
    private Date cl195;
    @Mapping(name = "cl196", typeMapping = OracleTypes.CHAR)
    public String cl196;
    @Mapping(name = "cl196", typeMapping = OracleTypes.DATE)
    private Date cd196;
    @Mapping(name = "cl197", typeMapping = OracleTypes.CHAR)
    public String cl197;
    @Mapping(name = "cl198", typeMapping = OracleTypes.CHAR)
    public String cl198;
    @Mapping(name = "cl199", typeMapping = OracleTypes.CHAR)
    public String cl199;
    private String fc000;
    @Mapping(name = "cn168", typeMapping = OracleTypes.CHAR)
    public String cn168;
    @Mapping(name = "cn168", typeMapping = OracleTypes.INTEGER)
    private int cn168int;
    @Mapping(name = "FQ100", typeMapping = OracleTypes.INTEGER)
    private int fq100;
    @Mapping(name = "cn169", typeMapping = OracleTypes.INTEGER)
    public int cn169;
    private String cn170;
    private String cn171;
    private String cn172;
    @Mapping(name = "together", typeMapping = OracleTypes.CHAR)
    public String together;
    @Mapping(name = "pic", typeMapping = OracleTypes.INTEGER)
    public int pic;
    @Mapping(name = "doc", typeMapping = OracleTypes.INTEGER)
    public int doc;
    @Mapping(name = "cv602", typeMapping = OracleTypes.CHAR)
    public String cv602;
    //field for note
    @Mapping(name = "pc300", typeMapping = OracleTypes.INTEGER)
    public int pc300;
    @Mapping(name = "childExist", typeMapping = OracleTypes.INTEGER)
    public int childExist;
    @Mapping(name = "edte", typeMapping = OracleTypes.INTEGER)
    public int edte;
    @Mapping(name = "dele", typeMapping = OracleTypes.INTEGER)
    public int dele;
    @Mapping(name = "pic2", typeMapping = OracleTypes.INTEGER)
    public int pic2;
    @Mapping(name = "doc2", typeMapping = OracleTypes.INTEGER)
    public int doc2;
    @Mapping(name = "sv201", typeMapping = OracleTypes.CHAR)
    public String sv201;
    @Mapping(name = "cb317", typeMapping = OracleTypes.CHAR)
    public String cb317;
    @Mapping(name = "cb173", typeMapping = OracleTypes.CHAR)
    public String cb173;
    @Mapping(name = "hv159", typeMapping = OracleTypes.CHAR)
    public String hv159;
    @Mapping(name = "cv305", typeMapping = OracleTypes.CHAR)
    public String cv305;
    @Mapping(name = "cl347", typeMapping = OracleTypes.CHAR)
    public String cl347;
    @Mapping(name = "cl349", typeMapping = OracleTypes.CHAR)
    public String cl349;
    @Mapping(name = "cl346", typeMapping = OracleTypes.CHAR)
    public String cl346;
    @Mapping(name = "cl348", typeMapping = OracleTypes.CHAR)
    public String cl348;
    @Mapping(name = "cn613", typeMapping = OracleTypes.CHAR)
    public String cn613;
    @Mapping(name = "cn602", typeMapping = OracleTypes.CHAR)
    public String cn602;
    @Mapping(name = "cv301", typeMapping = OracleTypes.CHAR)
    public String cv301;
    @Mapping(name = "login", typeMapping = OracleTypes.CHAR)
    private String login;
    @Mapping(name = "lst", typeMapping = OracleTypes.CHAR)
    private String lst;
    @Mapping(name = "notes", typeMapping = OracleTypes.INTEGER)
    private int notes;
    private int len;
    private String subString;
    @Mapping(name = "per", typeMapping = OracleTypes.CHAR)
    public String per;
    @Mapping(name = "SPVISORID", typeMapping = OracleTypes.INTEGER)
    public int supervisorId;
    private String hv159Sort;
    private String taskTitleSort;
    private List<C300> listC300;
    private int lengthCB173;
    @Mapping(name = "cn315", typeMapping = OracleTypes.INTEGER)
    private int cn315 = 0;
    @Mapping(name = "cv613", typeMapping = OracleTypes.CHAR)
    private String cv613;
    //more field to support in bean
    /**
     * dung trong viec cat truong cv158 ngan lai
     */
    public String cv158Sort;

    public C150() {
    }
    private C150 c150;

    public C150(String pc150, int fs200, int fs250, String fh150, String fc400, String fc650, String fc250, int fc450, String fc550, int fc500, int fn600, String cv151, Date cd152, Date cd153, String cv154, Date cd155, int cn156, String cv157, String cv158, String cv159, String cv160, String cv161, String cv162, String cv163, String cv164, String cv165, String cv166, String cv167, Date cl191, String cl192, Date cl193, String cl194, Date cl195, String cl196, String cl197, String cl198, String cl199, String fc000, String cn168, int cn169, String cn170, String cn171, String cn172, String together, int pic, int doc, int childExist, int edte, int dele) {
        this.pc150 = pc150;
        this.fs200 = fs200;
        this.fs250 = fs250;
        this.fh150 = fh150;
        this.fc400 = fc400;
        this.fc650 = fc650;
        this.fc250 = fc250;
        this.fc450 = fc450;
        this.fc550 = fc550;
        this.fc500 = fc500;
        this.fn600 = fn600;
        this.cv151 = cv151;
        this.cd152 = cd152;
        this.cd153 = cd153;
        this.cv154 = cv154;
        this.cd155 = cd155;
        this.cn156 = cn156;
        this.cv157 = cv157;
        this.cv158 = cv158;
        this.cv159 = cv159;
        this.cv160 = cv160;
        this.cv161 = cv161;
        this.cv162 = cv162;
        this.cv163 = cv163;
        this.cv164 = cv164;
        this.cv165 = cv165;
        this.cv166 = cv166;
        this.cv167 = cv167;
        this.cl191 = cl191;
        this.cl192 = cl192;
        this.cl193 = cl193;
        this.cl194 = cl194;
        this.cl195 = cl195;
        this.cl196 = cl196;
        this.cl197 = cl197;
        this.cl198 = cl198;
        this.cl199 = cl199;
        this.fc000 = fc000;
        this.cn168 = cn168;
        this.cn169 = cn169;
        this.cn170 = cn170;
        this.cn171 = cn171;
        this.cn172 = cn172;
        this.together = together;
        this.pic = pic;
        this.doc = doc;
        this.childExist = childExist;
        this.edte = edte;
        this.dele = dele;
    }

//    public int executeUpdateC150(){
//
//    }
    /**
     * @return the fs200
     */
    public int getFs200() {
        return fs200;
    }

    /**
     * @param fs200 the fs200 to set
     */
    public void setFs200(int fs200) {
        this.fs200 = fs200;
    }

    /**
     * @return the fh150
     */
    public String getFh150() {
        return fh150;
    }

    /**
     * @param fh150 the fh150 to set
     */
    public void setFh150(String fh150) {
        this.fh150 = fh150;
    }

    /**
     * @return the fc400
     */
    public String getFc400() {
        return fc400;
    }

    /**
     * @param fc400 the fc400 to set
     */
    public void setFc400(String fc400) {
        this.fc400 = fc400;
    }

    /**
     * @return the fc650
     */
    public String getFc650() {
        return fc650;
    }

    /**
     * @param fc650 the fc650 to set
     */
    public void setFc650(String fc650) {
        this.fc650 = fc650;
    }

    /**
     * @return the fc250
     */
    public String getFc250() {
        return fc250;
    }

    /**
     * @param fc250 the fc250 to set
     */
    public void setFc250(String fc250) {
        this.fc250 = fc250;
    }

    /**
     * @return the fc450
     */
    public int getFc450() {
        return fc450;
    }

    /**
     * @param fc450 the fc450 to set
     */
    public void setFc450(int fc450) {
        this.fc450 = fc450;
    }

    /**
     * @return the fc550
     */
    public String getFc550() {
        return fc550;
    }

    /**
     * @param fc550 the fc550 to set
     */
    public void setFc550(String fc550) {
        this.fc550 = fc550;
    }

    /**
     * @return the fc500
     */
    public int getFc500() {
        return fc500;
    }

    /**
     * @param fc500 the fc500 to set
     */
    public void setFc500(int fc500) {
        this.fc500 = fc500;
    }

    /**
     * @return the cv151
     */
    public String getCv151() {
        return cv151;
    }

    /**
     * @param cv151 the cv151 to set
     */
    public void setCv151(String cv151) {
        this.cv151 = cv151;
    }

    /**
     * @return the cd152
     */
    public Date getCd152() {
        return cd152;
    }

    /**
     * @param cd152 the cd152 to set
     */
    public void setCd152(Date cd152) {
        this.cd152 = cd152;
    }

    /**
     * @return the cd153
     */
    public Date getCd153() {
        return cd153;
    }

    /**
     * @param cd153 the cd153 to set
     */
    public void setCd153(Date cd153) {
        this.cd153 = cd153;
    }

    /**
     * @return the cv154
     */
    public String getCv154() {
        return cv154;
    }

    /**
     * @param cv154 the cv154 to set
     */
    public void setCv154(String cv154) {
        this.cv154 = cv154;
    }

    /**
     * @return the cd155
     */
    public Date getCd155() {
        return cd155;
    }

    /**
     * @param cd155 the cd155 to set
     */
    public void setCd155(Date cd155) {
        this.cd155 = cd155;
    }

    /**
     * @return the cn156
     */
    public int getCn156() {
        return cn156;
    }

    /**
     * @param cn156 the cn156 to set
     */
    public void setCn156(int cn156) {
        this.cn156 = cn156;
    }

    /**
     * @return the cv157
     */
    public String getCv157() {
        return cv157;
    }

    /**
     * @param cv157 the cv157 to set
     */
    public void setCv157(String cv157) {
        this.cv157 = cv157;
    }

    /**
     * @return the cv158
     */
    public String getCv158() {
        return cv158;
    }

    /**
     * @param cv158 the cv158 to set
     */
    public void setCv158(String cv158) {
        cv158Sort = getCv158().substring(1, 200);
        this.cv158 = cv158;
    }

    /**
     * @return the cv159
     */
    public String getCv159() {
        return cv159;
    }

    /**
     * @param cv159 the cv159 to set
     */
    public void setCv159(String cv159) {
        this.cv159 = cv159;
    }

    /**
     * @return the cv160
     */
    public String getCv160() {
        return cv160;
    }

    /**
     * @param cv160 the cv160 to set
     */
    public void setCv160(String cv160) {
        this.cv160 = cv160;
    }

    /**
     * @return the cv161
     */
    public String getCv161() {
        return cv161;
    }

    /**
     * @param cv161 the cv161 to set
     */
    public void setCv161(String cv161) {
        this.cv161 = cv161;
    }

    /**
     * @return the cv162
     */
    public String getCv162() {
        return cv162;
    }

    /**
     * @param cv162 the cv162 to set
     */
    public void setCv162(String cv162) {
        this.cv162 = cv162;
    }

    /**
     * @return the cv163
     */
    public String getCv163() {
        return cv163;
    }

    /**
     * @param cv163 the cv163 to set
     */
    public void setCv163(String cv163) {
        this.cv163 = cv163;
    }

    /**
     * @return the cv164
     */
    public String getCv164() {
        return cv164;
    }

    /**
     * @param cv164 the cv164 to set
     */
    public void setCv164(String cv164) {
        this.cv164 = cv164;
    }

    /**
     * @return the cv165
     */
    public String getCv165() {
        return cv165;
    }

    /**
     * @param cv165 the cv165 to set
     */
    public void setCv165(String cv165) {
        this.cv165 = cv165;
    }

    /**
     * @return the cv166
     */
    public String getCv166() {
        return cv166;
    }

    /**
     * @param cv166 the cv166 to set
     */
    public void setCv166(String cv166) {
        this.cv166 = cv166;
    }

    /**
     * @return the cv167
     */
    public String getCv167() {
        return cv167;
    }

    /**
     * @param cv167 the cv167 to set
     */
    public void setCv167(String cv167) {
        this.cv167 = cv167;
    }

    /**
     * @return the cl191
     */
    public Date getCl191() {
        return cl191;
    }

    /**
     * @param cl191 the cl191 to set
     */
    public void setCl191(Date cl191) {
        this.cl191 = cl191;
    }

    /**
     * @return the cl192
     */
    public String getCl192() {
        return cl192;
    }

    /**
     * @param cl192 the cl192 to set
     */
    public void setCl192(String cl192) {
        this.cl192 = cl192;
    }

    /**
     * @return the cl193
     */
    public Date getCl193() {
        return cl193;
    }

    /**
     * @param cl193 the cl193 to set
     */
    public void setCl193(Date cl193) {
        this.cl193 = cl193;
    }

    /**
     * @return the cl194
     */
    public String getCl194() {
        return cl194;
    }

    /**
     * @param cl194 the cl194 to set
     */
    public void setCl194(String cl194) {
        this.cl194 = cl194;
    }

    /**
     * @return the cl195
     */
    public Date getCl195() {
        return cl195;
    }

    /**
     * @param cl195 the cl195 to set
     */
    public void setCl195(Date cl195) {
        this.cl195 = cl195;
    }

    /**
     * @return the cl196
     */
    public String getCl196() {
        return cl196;
    }

    /**
     * @param cl196 the cl196 to set
     */
    public void setCl196(String cl196) {
        this.cl196 = cl196;
    }

    /**
     * @return the cl197
     */
    public String getCl197() {
        return cl197;
    }

    /**
     * @param cl197 the cl197 to set
     */
    public void setCl197(String cl197) {
        this.cl197 = cl197;
    }

    /**
     * @return the cl198
     */
    public String getCl198() {
        return cl198;
    }

    /**
     * @param cl198 the cl198 to set
     */
    public void setCl198(String cl198) {
        this.cl198 = cl198;
    }

    /**
     * @return the cl199
     */
    public String getCl199() {
        return cl199;
    }

    /**
     * @param cl199 the cl199 to set
     */
    public void setCl199(String cl199) {
        this.cl199 = cl199;
    }

    /**
     * @return the fc000
     */
    public String getFc000() {
        return fc000;
    }

    /**
     * @param fc000 the fc000 to set
     */
    public void setFc000(String fc000) {
        this.fc000 = fc000;
    }

    /**
     * @return the cn168
     */
    public String getCn168() {
        return cn168;
    }

    /**
     * @param cn168 the cn168 to set
     */
    public void setCn168(String cn168) {
        this.cn168 = cn168;
    }

    /**
     * @return the cn169
     */
    public int getCn169() {
        return cn169;
    }

    /**
     * @param cn169 the cn169 to set
     */
    public void setCn169(int cn169) {
        this.cn169 = cn169;
    }

    /**
     * @return the cn170
     */
    public String getCn170() {
        return cn170;
    }

    /**
     * @param cn170 the cn170 to set
     */
    public void setCn170(String cn170) {
        this.cn170 = cn170;
    }

    /**
     * @return the cn171
     */
    public String getCn171() {
        return cn171;
    }

    /**
     * @param cn171 the cn171 to set
     */
    public void setCn171(String cn171) {
        this.cn171 = cn171;
    }

    /**
     * @return the cn172
     */
    public String getCn172() {
        return cn172;
    }

    /**
     * @param cn172 the cn172 to set
     */
    public void setCn172(String cn172) {
        this.cn172 = cn172;
    }

    public static void main(String arg[]) throws SQLException, InstantiationException, IllegalAccessException {
        C150 c150 = new C150();
//        Calendar cl = Calendar.getInstance();
//        cl.add(Calendar.MONTH, 1);
//        Date endDate = new Date(cl.getTimeInMillis());
//        DataStatement sQLData = new DataStatement("BNEXC.Stdc_Tools.StornoTabC150", OracleTypes.INTEGER, new Param[]{
//                    new Param(OracleTypes.INTEGER, 300000588),
//                    new Param(OracleTypes.CHAR, "QBEE-226"),
//                    new Param(OracleTypes.CHAR, "tpv")
//                });
//        System.out.println(c150.update(sQLData, C150.class));

//        List lst = c150Services.ListOfTabC150B(0, "LVL");
        DataStatement dataContext = new DataStatement("CCURPKS.ListOfTabC150B", OracleTypes.CURSOR, new Param[]{
                    new Param(OracleTypes.NULL, null),
                    new Param(OracleTypes.INTEGER, 0),
                    new Param(OracleTypes.CHAR, "ctt")
                });
        DataStatement dataStatement = new DataStatement("Ccurpks.ListOfTabC150C", OracleTypes.CURSOR, new Param[]{
                    new Param(OracleTypes.CHAR, "TPV"),
                    new Param(OracleTypes.CHAR, null),
                    new Param(OracleTypes.INTEGER, null),
                    new Param(OracleTypes.INTEGER, null),
                    new Param(OracleTypes.CHAR, null),
                    new Param(OracleTypes.INTEGER, null),
                    new Param(OracleTypes.INTEGER, null),
                    new Param(OracleTypes.INTEGER, 1),
                    new Param(OracleTypes.INTEGER, 10000),
                    new Param(OracleTypes.INTEGER, null),
                    new Param(OracleTypes.INTEGER, 10000),
                    new Param(OracleTypes.INTEGER, null)
                });
        DataStatement dataStatement9 = new DataStatement("Ccurpks.ListOfTabC150C", OracleTypes.CURSOR, new Param[]{
                    new Param(OracleTypes.CHAR, "CTT"),
                    new Param(OracleTypes.CHAR, null),
                    new Param(OracleTypes.INTEGER, null),
                    new Param(OracleTypes.INTEGER, null),
                    new Param(OracleTypes.INTEGER, null),
                    new Param(OracleTypes.INTEGER, null),
                    new Param(OracleTypes.INTEGER, null),
                    new Param(OracleTypes.INTEGER, 100),
                    new Param(OracleTypes.INTEGER, 7)
                });

        DataStatement dataStatementWithNote = new DataStatement("Ccurpks.ListOfTabC150D", OracleTypes.CURSOR, new Param[]{
                    new Param(OracleTypes.CHAR, "CTT"),
                    new Param(OracleTypes.INTEGER, 300000341)
                });

        List<C150> lstC150 = c150.find(dataStatement9, C150.class);
        System.out.println(lstC150.size());
        for (int i = 0; i < lstC150.size(); i++) {
            C150 c1501 = lstC150.get(i);
            System.out.println("################## " + i + " ######################");
            Field[] fields = c1501.getClass().getDeclaredFields();
            for (int j = 0; j < fields.length; j++) {
                Field field = fields[j];
                System.out.println(field.getName() + ": " + field.get(c1501));
            }
            System.out.println("ÊÊÊÊÊÊÊÊ : " + c1501.getTaskTitleSort());
        }
    }

    /**
     * @return the together
     */
    public String getTogether() {
        return together;
    }

    /**
     * @param together the together to set
     */
    public void setTogether(String together) {
        this.together = together;
    }

    /**
     * @return the pic
     */
    public int getPic() {
        return pic;
    }

    /**
     * @param pic the pic to set
     */
    public void setPic(int pic) {
        this.pic = pic;
    }

    /**
     * @return the doc
     */
    public int getDoc() {
        return doc;
    }

    /**
     * @param doc the doc to set
     */
    public void setDoc(int doc) {
        this.doc = doc;
    }

    /**
     * @return the childExist
     */
    public int getChildExist() {
        return childExist;
    }

    /**
     * @param childExist the childExist to set
     */
    public void setChildExist(int childExist) {
        this.childExist = childExist;
    }

    /**
     * @return the edte
     */
    public int getEdte() {
        return edte;
    }

    /**
     * @param edte the edte to set
     */
    public void setEdte(int edte) {
        this.edte = edte;
    }

    /**
     * @return the dele
     */
    public int getDele() {
        return dele;
    }

    /**
     * @param dele the dele to set
     */
    public void setDele(int dele) {
        this.dele = dele;
    }

    /**
     * @return the cv158Sort
     */
    public String getCv158Sort() {
        return cv158Sort;
    }

    /**
     * @param cv158Sort the cv158Sort to set
     */
    public void setCv158Sort(String cv158Sort) {
        this.cv158Sort = cv158Sort;
    }

    /**
     * @return the sv201
     */
    public String getSv201() {
        return sv201;
    }

    /**
     * @param sv201 the sv201 to set
     */
    public void setSv201(String sv201) {
        this.sv201 = sv201;
    }

    /**
     * @return the cb317
     */
    public String getCb317() {
        if (getCb173().length() > 200) {
            getCb173().substring(1, 200);
            System.out.println("SSSSSSSSSSSSSSSSSSSSSSS" + getCb173());
        }
        return cb317;
    }

    /**
     * @param cb317 the cb317 to set
     */
    public void setCb317(String cb317) {
        this.cb317 = cb317;
    }

    /**
     * @return the hv159
     */
    public String getHv159() {
        return hv159;
    }

    /**
     * @param hv159 the hv159 to set
     */
    public void setHv159(String hv159) {
        this.hv159 = hv159;
    }

    /**
     * @return the taskTitleSort
     */
    public String getTaskTitleSort() {
        if (cv158.length() > 18) {
            taskTitleSort = cv158.substring(0, 18) + "...";
        } else {
            taskTitleSort = cv158;
        }
        return taskTitleSort;
    }

    /**
     * @param taskTitleSort the taskTitleSort to set
     */
    public void setTaskTitleSort(String taskTitleSort) {
        this.taskTitleSort = taskTitleSort;
    }

    /**
     * @return the cb173
     */
    public String getCb173() {
        return cb173;
    }

    /**
     * @param cb173 the cb173 to set
     */
    public void setCb173(String cb173) {
        this.cb173 = cb173;
    }

    /**
     * @return the cv305
     */
    public String getCv305() {
        return cv305;
    }

    /**
     * @param cv305 the cv305 to set
     */
    public void setCv305(String cv305) {
        this.cv305 = cv305;
    }

    /**
     * @return the cl346
     */
    public String getCl346() {
        return cl346;
    }

    /**
     * @param cl346 the cl346 to set
     */
    public void setCl346(String cl346) {
        this.cl346 = cl346;
    }

    /**
     * @return the cl348
     */
    public String getCl348() {
        return cl348;
    }

    /**
     * @param cl348 the cl348 to set
     */
    public void setCl348(String cl348) {
        this.cl348 = cl348;
    }

    /**
     * @return the cl347
     */
    public String getCl347() {
        return cl347;
    }

    /**
     * @param cl347 the cl347 to set
     */
    public void setCl347(String cl347) {
        this.cl347 = cl347;
    }

    /**
     * @return the cl349
     */
    public String getCl349() {
        return cl349;
    }

    /**
     * @param cl349 the cl349 to set
     */
    public void setCl349(String cl349) {
        this.cl349 = cl349;
    }

    /**
     * @return the pic2
     */
    public int getPic2() {
        return pic2;
    }

    /**
     * @param pic2 the pic2 to set
     */
    public void setPic2(int pic2) {
        this.pic2 = pic2;
    }

    /**
     * @return the doc2
     */
    public int getDoc2() {
        return doc2;
    }

    /**
     * @param doc2 the doc2 to set
     */
    public void setDoc2(int doc2) {
        this.doc2 = doc2;
    }

    /**
     * @return the cn613
     */
    public String getCn613() {
        return cn613;
    }

    /**
     * @param cn613 the cn613 to set
     */
    public void setCn613(String cn613) {
        this.cn613 = cn613;
    }

    /**
     * @return the hv159Sort
     */
    public String getHv159Sort() {
        if (hv159.length() > 15) {
            hv159Sort = hv159.substring(0, 14) + "...";
        } else {
            hv159Sort = hv159;
        }
        return hv159Sort;
    }

    /**
     * @param hv159Sort the hv159Sort to set
     */
    public void setHv159Sort(String hv159Sort) {
        this.hv159Sort = hv159Sort;
    }

    /**
     * @return the notes
     */
    public int getNotes() {
        return notes;
    }

    /**
     * @param notes the notes to set
     */
    public void setNotes(int notes) {
        this.notes = notes;
    }

    /**
     * @return the listC300
     */
    public List<C300> getListC300() {
        return listC300;
    }

    /**
     * @param listC300 the listC300 to set
     */
    public void setListC300(List<C300> listC300) {
        this.listC300 = listC300;
    }

    /**
     * @return the cn602
     */
    public String getCn602() {
        return cn602;
    }

    /**
     * @param cn602 the cn602 to set
     */
    public void setCn602(String cn602) {
        this.cn602 = cn602;
    }

    /**
     * @return the per
     */
    public String getPer() {
        return per;
    }

    /**
     * @param per the per to set
     */
    public void setPer(String per) {
        this.per = per;
    }

    /**
     * @return the supervisorId
     */
    public int getSupervisorId() {
        return supervisorId;
    }

    /**
     * @param supervisorId the supervisorId to set
     */
    public void setSupervisorId(int supervisorId) {
        this.supervisorId = supervisorId;
    }

    /**
     * @return the pc300
     */
    public int getPc300() {
        return pc300;
    }

    /**
     * @param pc300 the pc300 to set
     */
    public void setPc300(int pc300) {
        this.pc300 = pc300;
    }

    /**
     * @return the cv306
     */
    public String getCv602() {
        return cv602;
    }

    /**
     * @param cv306 the cv306 to set
     */
    public void setCv602(String cv602) {
        this.cv602 = cv602;
    }

    /**
     * @return the cv301
     */
    public String getCv301() {
        return cv301;
    }

    /**
     * @param cv301 the cv301 to set
     */
    public void setCv301(String cv301) {
        this.cv301 = cv301;
    }

    /**
     * @return the pc150
     */
    public String getPc150() {
        return pc150;
    }

    /**
     * @param pc150 the pc150 to set
     */
    public void setPc150(String pc150) {
        this.pc150 = pc150;
    }

    public String getSubString() {
        if (getCb173() != null) {
            if (getCb173().length() > 200) {
                subString = getCb173().substring(0, 200);
                System.out.println("CCCCCCCCCCCCCC" + subString);
            } else {
                subString = getCb173().toString();
            }
        }
        return subString;
    }

    /**
     * @param pc150 the pc150 to set
     */
    public void setSubString(String subString) {
        this.subString = subString;
    }

    public int getPn100() {
        return pn100;
    }

    /**
     * @param PN350 the PN350 to set
     */
    public void setPn100(int pn100) {
        this.pn100 = pn100;
    }

    public int getFn600() {
        return fn600;
    }

    /**
     * @param PN350 the PN350 to set
     */
    public void setFn600(int fn600) {
        this.fn600 = fn600;
    }

    /**
     * @return the pb050
     */
    public int getPb050() {
        return pb050;
    }

    /**
     * @param pb050 the pb050 to set
     */
    public void setPb050(int pb050) {
        this.pb050 = pb050;
    }

    /**
     * @return the fs250
     */
    public int getFs250() {
        return fs250;
    }

    /**
     * @param fs250 the fs250 to set
     */
    public void setFs250(int fs250) {
        this.fs250 = fs250;
    }

    public int getLen() {
        len = getCb173().length();

        return len;
    }

    /**
     * @param fs250 the fs250 to set
     */
    public void setLen(int len) {
        this.len = len;
    }

    /**
     * @return the login
     */
    public String getLogin() {
        return login;
    }

    /**
     * @param login the login to set
     */
    public void setLogin(String login) {
        this.login = login;
    }

    /**
     * @return the cn168int
     */
    public int getCn168int() {
        return cn168int;
    }

    /**
     * @param cn168int the cn168int to set
     */
    public void setCn168int(int cn168int) {
        this.cn168int = cn168int;
    }

    /**
     * @return the lst
     */
    public String getLst() {
        return lst;
    }

    /**
     * @param lst the lst to set
     */
    public void setLst(String lst) {
        this.lst = lst;
    }

    /**
     * @return the lengthCB173
     */
    public int getLengthCB173() {
        return lengthCB173;
    }

    /**
     * @param lengthCB173 the lengthCB173 to set
     */
    public void setLengthCB173(int lengthCB173) {
        this.lengthCB173 = lengthCB173;
    }

    /**
     * @return the fv050
     */
    public int getFv050() {
        return fv050;
    }

    /**
     * @param fv050 the fv050 to set
     */
    public void setFv050(int fv050) {
        this.fv050 = fv050;
    }

        /**
     * @return the vn034
     */
    public int getVn034() {
        return vn034;
    }

    /**
     * @param vn034 the vn034 to set
     */
    public void setVn034(int vn034) {
        this.vn034 = vn034;
    }
    
    /**
     * @return the c150
     */
    public C150 getC150() {
        return c150;
    }

    /**
     * @param c150 the c150 to set
     */
    public void setC150(C150 c150) {
        this.c150 = c150;
    }

    /**
     * @return the cn315
     */
    public int getCn315() {
        return cn315;
    }

    /**
     * @param cn315 the cn315 to set
     */
    public void setCn315(int cn315) {
        this.cn315 = cn315;
    }

    /**
     * @return the cv613
     */
    public String getCv613() {
        return cv613;
    }

    /**
     * @param cv613 the cv613 to set
     */
    public void setCv613(String cv613) {
        this.cv613 = cv613;
    }

    /**
     * @return the cd196
     */
    public Date getCd196() {
        return cd196;
    }

    /**
     * @param cd196 the cd196 to set
     */
    public void setCd196(Date cd196) {
        this.cd196 = cd196;
    }

    /**
     * @return the fq100
     */
    public int getFq100() {
        return fq100;
    }

    /**
     * @param fq100 the fq100 to set
     */
    public void setFq100(int fq100) {
        this.fq100 = fq100;
    }

    /**
     * @return the row
     */
    public int getRow() {
        return row;
    }

    /**
     * @param row the row to set
     */
    public void setRow(int row) {
        this.row = row;
    }
}
